Adding A Field To A Query

You can very easily add additional fields to this query. We will add two additional fields.

Click the View button on the toolbar


    Access displays your query in design view.

Click the down arrow on the scroll bar in the Sales field list until the Qnty and Price fields appear.

Double-click Qnty
Double-click Price

Click the Run button on the toolbar.

    Your query should look like the one below:

Now you try!